filepath = "/content/drive/MyDrive/bgb/"

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
ind_year_count = pd.read_excel('/content/drive/MyDrive/bgb/bb_industry_year_count_v.xlsx')
ind_year_count

ind_year_count.shape[0]

df=ind_year_count.pivot('Industry','Year','Count')
plt.rcParams['figure.figsize'] = [18, 12]
sns.heatmap(df, annot=True, fmt='d', cmap='YlGnBu')
plt.xticks(np.arange(0.5, len(df.columns), 1), df.columns)
plt.yticks(np.arange(0.5, len(df.index), 1), df.index)
plt.xlabel('Year', fontsize=18)
plt.ylabel('Industry', fontsize=18)
plt.show()

ind_count = pd.read_excel('/content/drive/MyDrive/bgb/bb_industry_count_v.xlsx')
ind_count

Count=ind_count.Count
Count

plt.figure(figsize = (12,12))
g = sns.barplot(x='Count', y='Industry', data=ind_count, alpha=0.8, palette='RdBu')
for i in range(ind_count.shape[0]):
    g.text(x=Count[i], y=i, s=Count[i], horizontalalignment='left', verticalalignment='center')
plt.show()